MTPASA

Total Availability

MTPASA Change 

"regions = pd.DataFrame({'RegionID': ['NSW1','QLD1','SA1','VIC1','TAS1']})\ndate1 = pd.DataFrame({'Date1': regional_df.Publish_Datetime.unique()})\ndate2 = pd.DataFrame({'Date2': regional_df.Publish_Datetime.unique()})\n\n# define selection dropdowns\nregion_dropdown = alt.binding_select(options=list(regions.RegionID))\nregion_selection = alt.selection_single(bind=region_dropdown, fields=['RegionID'], name='Region_')\n\ndate1_dropdown = alt.binding_select(options=list(date1.Date1))\ndate1_selection = alt.selection_single(bind=date1_dropdown, fields=['Publish_Datetime'])\n\ndate2_dropdown = alt.binding_select(options=list(date2.Date2))\ndate2_selection = alt.selection_single(bind=date2_dropdown, fields=['Publish_Datetime'])\n\ncolor = alt.condition(date1_selection, alt.Color('RegionID:N'), alt.value('lightgray'))\n\nchart = alt.Chart(regional_df).mark_rect().encode(\n    x='Date',\n    y='Availability',\n    color='Publish_Datetime',\n    opacity=alt.condition(\n        (region_selection & (date1_selection | date2_selection)),\n    ))\n\nchart"
alt.data_transformers.disable_max_rows()    # altair doesnt plot > 5000 row DFs... disable this (think about longer-term file size consequences)
#scratch - using just one dropdown to start
region_selection = alt.selection_multi(fields=['RegionID'])
region_color = alt.condition(region_selection, alt.Color('RegionID:N'), alt.value('lightgray'))
make_region_selector = alt.Chart(region_selection).mark_rect().encode(y='RegionID', color=region_color).add_selection(region_selection)

chart = alt.Chart(regional_df).mark_line().encode(
    x='Day', y=alt.Y('PasaAvailability'), color='RegionID').transform_filter(region_selection).properties(
    width=650, height=400, title='Regional MTPASA by Date').interactive()

chart

STPASA